<!--
 * @Descripttion: (数据库采集配置表/database_collection_config)
 * @Author: (admin)
 * @Date: (2025-10-04)
-->
<template>
    <div>
      <el-form :model="queryParams" label-position="right" inline ref="queryRef" v-show="showSearch" @submit.prevent>
        <el-form-item>
          <el-button icon="search" type="primary" @click="handleQuery">{{ $t('btn.search') }}</el-button>
          <el-button icon="refresh" @click="resetQuery">{{ $t('btn.reset') }}</el-button>
        </el-form-item>
      </el-form>
      <!-- 工具区域 -->
      <el-row :gutter="15" class="mb10">
        <el-col :span="1.5">
          <el-button type="primary" v-hasPermi="['databasecollectionconfig:add']" plain icon="plus" @click="handleAdd">
            {{ $t('btn.add') }}
          </el-button>
        </el-col>
        <right-toolbar v-model:showSearch="showSearch" @queryTable="getList" :columns="columns"></right-toolbar>
      </el-row>
  
      <el-table
        :data="dataList"
        v-loading="loading"
        ref="table"
        border
        header-cell-class-name="el-table-header-cell"
        highlight-current-row
        @sort-change="sortChange"
        >
        <!-- <el-table-column prop="id" label="自增主键" align="center" v-if="columns.showColumn('id')"/> -->
        <el-table-column prop="businessCode" label="业务编码" align="center" :show-overflow-tooltip="true" >
            <template #default="scope">
                <el-link type="primary" @click="showTables(scope.row)">{{ scope.row.businessCode }}</el-link>
            </template>
        </el-table-column>
        
        <el-table-column prop="deviceName" label="设备名称" align="center" :show-overflow-tooltip="true" v-if="columns.showColumn('deviceName')"/>
        <el-table-column prop="ip" label="IP地址" align="center" :show-overflow-tooltip="true" v-if="columns.showColumn('ip')"/>
        <el-table-column prop="port" label="端口号" align="center" v-if="columns.showColumn('port')"/>
        <el-table-column prop="type" label="设备类型" align="center" v-if="columns.showColumn('type')">
          <template #default="scope">
            <dict-tag :options=" options.typeOptions" :value="scope.row.type"  />
          </template>
        </el-table-column>
        <el-table-column prop="dataBase" label="数据库名称" align="center" :show-overflow-tooltip="true" v-if="columns.showColumn('dataBase')"/>
        <el-table-column prop="uid" label="用户名" align="center" :show-overflow-tooltip="true" v-if="columns.showColumn('uid')"/>
        <el-table-column prop="pwd" label="密码" align="center" :show-overflow-tooltip="true" v-if="columns.showColumn('pwd')"/>
        <el-table-column prop="nullity" label="Nullity" align="center" v-if="columns.showColumn('nullity')"/>
        <el-table-column prop="createdTime" label="CreatedTime" :show-overflow-tooltip="true"  v-if="columns.showColumn('createdTime')"/>
        <el-table-column prop="isDeleted" label="IsDeleted" align="center" v-if="columns.showColumn('isDeleted')">
          <template #default="scope">
            <dict-tag :options=" options.isDeletedOptions" :value="scope.row.isDeleted"  />
          </template>
        </el-table-column>
        <el-table-column label="操作" width="160">
          <template #default="scope">
            <el-button type="success" size="small" icon="edit" title="编辑" v-hasPermi="['databasecollectionconfig:edit']" @click="handleUpdate(scope.row)"></el-button>
            <el-button type="danger" size="small" icon="delete" title="删除" v-hasPermi="['databasecollectionconfig:delete']" @click="handleDelete(scope.row)"></el-button>
          </template>
        </el-table-column>
      </el-table>
      <pagination :total="total" v-model:page="queryParams.pageNum" v-model:limit="queryParams.pageSize" @pagination="getList" />
  
  
      <!-- 添加或修改数据库采集配置表对话框 -->
      <el-dialog :title="title" :lock-scroll="false" v-model="open" >
        <el-form ref="formRef" :model="form" :rules="rules" label-width="100px" :hide-required-asterisk="true">
          <el-row :gutter="20">
              
            <!-- <el-col :lg="12" v-if="opertype != 1">
              <el-form-item label="自增主键" prop="id">
                <el-input-number v-model.number="form.id" controls-position="right" placeholder="请输入自增主键" :disabled="true"/>
              </el-form-item>
            </el-col> -->
  
            <el-col :lg="12">
              <el-form-item label="业务编码" prop="businessCode">
                <el-input v-if="opertype != 1" :disabled="true" v-model="form.businessCode" placeholder="请输入业务编码，用于业务关联" />
                <el-input v-else v-model="form.businessCode" placeholder="请输入业务编码，用于业务关联" />  
            </el-form-item>
            </el-col>
  
            <el-col :lg="12">
              <el-form-item label="设备名称" prop="deviceName">
                <el-input v-model="form.deviceName" placeholder="请输入设备名称" />
              </el-form-item>
            </el-col>
  
            <el-col :lg="12">
              <el-form-item label="IP地址" prop="ip">
                <el-input v-model="form.ip" placeholder="请输入IP地址" />
              </el-form-item>
            </el-col>
              
            <el-col :lg="12">
              <el-form-item label="端口号" prop="port">
                <el-input v-model.number="form.port" placeholder="请输入端口号" />
              </el-form-item>
            </el-col>
  
            <el-col :lg="12">
              <el-form-item label="设备类型" prop="type">
                <el-select v-model="form.type"  placeholder="请选择设备类型">
                  <el-option
                    v-for="item in options.typeOptions" 
                    :key="item.dictValue" 
                    :label="item.dictLabel" 
                    :value="item.dictValue"></el-option>
                </el-select>
              </el-form-item>
            </el-col>
  
            <el-col :lg="12">
              <el-form-item label="数据库名称" prop="dataBase">
                <el-input v-model="form.dataBase" placeholder="请输入数据库名称" />
              </el-form-item>
            </el-col>
  
            <el-col :lg="12">
              <el-form-item label="用户名" prop="uid">
                <el-input v-model="form.uid" placeholder="请输入用户名" />
              </el-form-item>
            </el-col>
  
            <el-col :lg="12">
              <el-form-item label="密码" prop="pwd">
                <el-input v-model="form.pwd" placeholder="请输入密码" />
              </el-form-item>
            </el-col>
  
            
  
            
          </el-row>
        </el-form>
        <template #footer v-if="opertype != 3">
          <el-button text @click="cancel">{{ $t('btn.cancel') }}</el-button>
          <el-button type="primary" @click="submitForm">{{ $t('btn.submit') }}</el-button>
        </template>
      </el-dialog>

      <el-dialog v-model="businessPageVisible" draggable width="60%" :lock-scroll="false">
        <table-data v-model:row="editRow" :visible="businessPageVisible"></table-data>
      </el-dialog>

    </div>
  </template>
  
  <script setup name="databasecollectionconfig">
  import { listDatabaseCollectionConfig,
   addDatabaseCollectionConfig, delDatabaseCollectionConfig, 
   updateDatabaseCollectionConfig,getDatabaseCollectionConfig, 
   } 
  from '@/api/business/databasecollectionconfig.js'
  import tableData from './components/tableData'
  const { proxy } = getCurrentInstance()
  const ids = ref([])
  const loading = ref(false)
  const showSearch = ref(true)
  const queryParams = reactive({
    pageNum: 1,
    pageSize: 10,
    sort: '',
    sortType: 'asc',
  })
  const columns = ref([
    { visible: true, prop: 'id', label: '自增主键' },
    { visible: true, prop: 'businessCode', label: '业务编码，用于业务关联' },
    { visible: true, prop: 'deviceName', label: '设备名称' },
    { visible: true, prop: 'ip', label: 'IP地址' },
    { visible: true, prop: 'port', label: '端口号' },
    { visible: true, prop: 'type', label: '设备类型' },
    { visible: true, prop: 'dataBase', label: '数据库名称' },
    { visible: true, prop: 'uid', label: '用户名' },
    { visible: false, prop: 'pwd', label: '密码' },
    { visible: false, prop: 'nullity', label: 'Nullity' },
    { visible: false, prop: 'createdTime', label: 'CreatedTime' },
    { visible: false, prop: 'isDeleted', label: 'IsDeleted' },
  ])
  const total = ref(0)
  const dataList = ref([])
  const queryRef = ref()
  const defaultTime = ref([new Date(2000, 1, 1, 0, 0, 0), new Date(2000, 2, 1, 23, 59, 59)])
  
  
  var dictParams = [
  ]
  
  
  function getList(){
    loading.value = true
    listDatabaseCollectionConfig(queryParams).then(res => {
      const { code, data } = res
      if (code == 200) {
        dataList.value = data.result
        total.value = data.totalNum
        loading.value = false
      }
    })
  }
  
  // 查询
  function handleQuery() {
    queryParams.pageNum = 1
    getList()
  }
  
  // 重置查询操作
  function resetQuery(){
    proxy.resetForm("queryRef")
    handleQuery()
  }
  // 自定义排序
  function sortChange(column) {
    var sort = undefined
    var sortType = undefined
  
    if (column.prop != null && column.order != null) {
      sort = column.prop
      sortType = column.order
  
    }
    queryParams.sort = sort
    queryParams.sortType = sortType
    handleQuery()
  }
  
  /*************** form操作 ***************/
  const formRef = ref()
  const title = ref('')
  // 操作类型 1、add 2、edit 3、view
  const opertype = ref(0)
  const open = ref(false)
  const state = reactive({
    single: true,
    multiple: true,
    form: {},
    rules: {
      businessCode: [{ required: true, message: "业务编码，用于业务关联不能为空", trigger: "blur"     }],
      deviceName: [{ required: true, message: "设备名称不能为空", trigger: "blur"     }],
      ip: [{ required: true, message: "IP地址不能为空", trigger: "blur"     }],
      port: [{ required: true, message: "端口号不能为空", trigger: "blur"    , type: "number"  }],
      type: [{ required: true, message: "设备类型不能为空", trigger: "change"     }],
      nullity: [{ required: true, message: "Nullity不能为空", trigger: "blur"     }],
      isDeleted: [{ required: true, message: "IsDeleted不能为空", trigger: "blur"     }],
    },
    options: {
      // 设备类型 选项列表 格式 eg:{ dictLabel: '标签', dictValue: '0'}
  typeOptions: [
  { dictLabel: 'Mysql', dictValue: '0'},
  { dictLabel: 'SqlServer', dictValue: '1'},
  ],
    }
  })
  
  const { form, rules, options, single, multiple } = toRefs(state)
  
  // 关闭dialog
  function cancel(){
    open.value = false
    reset()
  }
  
  // 重置表单
  function reset() {
    form.value = {
      id: null,
      businessCode: null,
      deviceName: null,
      ip: null,
      port: null,
      type: null,
      dataBase: null,
      uid: null,
      pwd: null,
      nullity: null,
      createdTime: null,
      isDeleted: null,
    };
    proxy.resetForm("formRef")
  }
  
  
  // 添加按钮操作
  function handleAdd() {
    reset();
    open.value = true
    title.value = '添加数据库采集配置表'
    opertype.value = 1
  }
  // 修改按钮操作
  function handleUpdate(row) {
    reset()
    const id = row.id || ids.value
    getDatabaseCollectionConfig(id).then((res) => {
      const { code, data } = res
      if (code == 200) {
        open.value = true
        title.value = '修改数据库采集配置表'
        opertype.value = 2
  
        form.value = {
          ...data,
        }
      }
    })
  }
  
  // 添加&修改 表单提交
  function submitForm() {
    proxy.$refs["formRef"].validate((valid) => {
      if (valid) {
  
        if (form.value.id != undefined && opertype.value === 2) {
          updateDatabaseCollectionConfig(form.value).then((res) => {
            proxy.$modal.msgSuccess("修改成功")
            open.value = false
            getList()
          })
        } else {
          addDatabaseCollectionConfig(form.value).then((res) => {
              proxy.$modal.msgSuccess("新增成功")
              open.value = false
              getList()
            })
        }
      }
    })
  }
  
  // 删除按钮操作
  function handleDelete(row) {
    const Ids = row.id || ids.value
  
    proxy
      .$confirm('是否确认删除参数编号为"' + Ids + '"的数据项？', "警告", {
        confirmButtonText: proxy.$t('common.ok'),
        cancelButtonText: proxy.$t('common.cancel'),
        type: "warning",
      })
      .then(function () {
        return delDatabaseCollectionConfig(Ids)
      })
      .then(() => {
        getList()
        proxy.$modal.msgSuccess("删除成功")
      })
  }
  
  
  
  
  
  handleQuery()


  const businessPageVisible = ref(false)
  const editRow = ref(null)
  function showTables(row){
   
    editRow.value = row
    businessPageVisible.value = true
  }




  </script>